ODBC gives you more control over which parts of a database you can use. For this reason, using an Access query through ODBC may require a few extra steps.
Tip: Choosing ODBC as your data source automatically logs you onto the server.
If you did not specify a particular Access database file with your Access ODBC data source, the Select Database dialog box appears.
Note: If your database requires a user name and password, or any other log on information, a log on dialog box appears.
If you selected the "Reprompt user when connecting" check box in the Options dialog box, the Allow Reporting On dialog box appears. Otherwise, skip to Step 9.
The Design tab appears along with the Field Explorer dialog box. Your Access query, and all fields associated with that query, appear under "Database Fields."
Note: You cannot use Access Action queries or Update queries in Crystal Reports. However, you can use Access Select queries and Cross
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |